DECLARE @counter INT;
SET @counter = 1;

WHILE (@counter < 10)
BEGIN
    PRINT 'Counter: ' + CAST(@counter AS NVARCHAR(10));
    SET @counter = @counter + 1;
END;
